﻿using System;
namespace BZZ.Model
{
	/// <summary>
	/// 书籍列表实体类：book 。
	/// </summary>
	[Serializable]
	public class book
	{
		public book()
		{}

		#region Model
		private int _id; //id
		private string _cata; //类别
		private string _bookName; //书名
		private string _about; //介绍
		private int _sortid; //排序
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 类别
		/// </summary>
		public string cata
		{
			set{ _cata=value;}
			get{return _cata;}
		}
        /// <summary>
		/// 书名
		/// </summary>
		public string bookName
		{
			set{ _bookName=value;}
			get{return _bookName;}
		}
        /// <summary>
		/// 介绍
		/// </summary>
		public string about
		{
			set{ _about=value;}
			get{return _about;}
		}
        /// <summary>
		/// 排序
		/// </summary>
		public int sortid
		{
			set{ _sortid=value;}
			get{return _sortid;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
书籍列表,book
id,类别,书名,介绍,排序,扩展1,扩展2
id,cata,bookName,about,sortid,ext1,ext2
i,c20,c100,c500,i,c100,c100

--------------------------
-- 创建表[书籍列表]开始: 
-- alter table  [BZZ_book] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='BZZ_book') drop table BZZ_book
  CREATE TABLE [BZZ_book] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [cata] [varchar] (20),
	 [bookName] [varchar] (100),
	 [about] [varchar] (500),
	 [sortid] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'书籍列表 ',N'user',N'dbo',N'table',N'BZZ_book', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'BZZ_book',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'类别',N'user',N'dbo',N'table',N'BZZ_book',N'column',N'cata'
 exec sp_addextendedproperty N'MS_Description',N'书名',N'user',N'dbo',N'table',N'BZZ_book',N'column',N'bookName'
 exec sp_addextendedproperty N'MS_Description',N'介绍',N'user',N'dbo',N'table',N'BZZ_book',N'column',N'about'
 exec sp_addextendedproperty N'MS_Description',N'排序',N'user',N'dbo',N'table',N'BZZ_book',N'column',N'sortid'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'BZZ_book',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'BZZ_book',N'column',N'ext2'

-- 创建表[书籍列表]结束。 
--------------------------

		*/
		#endregion document
	}
}

